const db = require('../db/index')

// 获取文章列表
exports.getArticleCates = (req, res) => {
const sql = 'select * from ev_article_cate where is_delete=0 order by id asc'
db.query(sql, (err, results) => {
if (err) return res.cc(err)
res.send({
status: 0,
message: '获取文章分类列表成功！',
data: results,
})
})
// res.send('ArticleCates')
}
exports.addArticleCates = (req, res) => {
const sql = `select * from ev_article_cate where name=? or alias=?`
db.query(sql, [req.body.name,req.body.alias],(err, results) => {
	console.log(results)
if (err) return res.cc(err)
if (results.length === 2)
   return res.cc('分类名称与别名被占用，请更换后重试！')
if (results.length === 1 && results[0].name === req.body.name)
   return res.cc('分类名称被占用，请更换后重试！')
if (results.length === 1 && results[0].alias === req.body.alias)
	return res.cc('分类别名被占用，请更换后重试！')
	// 插入
	
	let sql=`insert into ev_article_cate set ?`
	db.query(sql, req.body, (err, resu) => {
	if (err) return res.cc(err)
	if (resu.affectedRows !== 1) return res.cc('新增文章分类失败！')
	res.send({
	status: 0,
	message: '新增文章分类成功！',
	data: results,
	})
	
	})
})
}

exports.deleteCateById = (req, res) => {
const sql = `update ev_article_cate set is_delete=1 where id=?`
db.query(sql, req.params.id, (err, results) => {
if (err) return res.cc(err)
if (results.affectedRows !== 1) return res.cc('删除文章分类失败！')
res.send({
	status: 0,
	message: '删除文章分类成功！',
	data: results,
	})
})
}
exports.getArticleById = (req, res) => {
let sql=`select * from ev_article_cate where id=?`
db.query(sql, req.params.id, (err, results) => {
if (err) return res.cc(err)
console.log(results)
if (results.length==0) return res.cc('失败！')
res.send({
	status: 0,
	message: '成功！',
	data: results[0],
	})
})
}

exports.updateCateById = (req, res) => {
const sql = `update ev_article_cate set ? where id=?`
db.query(sql, [req.body, req.body.id], (err, results) => {
if (err) return res.cc(err)
if (results.affectedRows !== 1) return res.cc('更新文章分类失败！')
res.send({
	status: 0,
	message: '修改成功！',
	})
})
}